package com.hs.sharding.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hs.sharding.entity.UserInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Description: UserInfo Mapper接口
 * @Author 胡尚
 * @Date: 2024/8/4 12:37
 */
@Mapper
public interface UserInfoMapper extends BaseMapper<UserInfo> {

    @Select("select info.* from sys_user as u, user_info as info where u.uid = info.uid")
    List<UserInfo> queryUserInfo();
}
